﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace O.M.Production.Domain.Entity
{

    /// <summary>
    /// 产品物料关系表
    /// </summary>
    [SugarTable("produce_material")]
    public class produce_material 
    {
        /// <summary>
        /// 物料id
        /// </summary>
        [SugarColumn(IsPrimaryKey = true, ColumnDescription = "物料id",IsIdentity =true)]
        public int produce_material_id {  get; set; }
        /// <summary>
        /// 物料编号
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料编号")]
        public string? material_code { get; set; }

        /// <summary>
        /// 生产编号
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "生产编号")]
        public string? internal_product_id { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料名称")]
        public string? material_name { get; set; }
        /// <summary>
        /// 物料规格
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "物料规格")]
        public string? material_material { get; set; }
        /// <summary>
        /// 计重单位
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "计重单位")]
        public string? weight_unit { get; set; }
        /// <summary>
        /// 仓库
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "仓库",IsNullable =true)]
        public string? storehouse { get; set; }
        /// <summary>
        /// 库存
        /// </summary>
        [SugarColumn(ColumnDescription = "库存")]
        public int stock { get; set; }
        /// <summary>
        /// 计划消耗数量
        /// </summary>
        [SugarColumn(ColumnDescription = "计划消耗数量")]
        public int planned_consumption_quantity { get; set; }
        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "备注")]
        public string? remarks { get; set; }
    }
}
